package com.soft.springhrms.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.soft.springhrms.pojo.Employees;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * @author DELL
 * @description 针对表【employees】的数据库操作Mapper
 * @createDate 2024-11-16 18:48:18
 * @Entity com.soft.springhrms.pojo.Employees
 */
@Mapper
public interface EmployeesMapper extends BaseMapper<Employees> {
    IPage<Employees> getEmployeesWithPagination(Page<Employees> page, @Param("keyword") String keyword);

    Integer countByDepartment(@Param("Param")Integer departmentId);

    Integer countByPosition(@Param("Param")Integer positionId);

    List<Employees> selectEmployeesList();

    IPage<Employees> getEmployeesAsNoAttendance(Page<Employees> employeePage, @Param("date") String date);

    List<Map<String, Object>> getDepartmentEcharts();

    List<Map<String, Object>> getPositionEcharts(@Param("departmentId")Integer departmentId);
}




